-- SQL Loader Control and Data File created by TOAD
-- Variable length, terminated enclosed data formatting
-- 
-- The format for executing this file with SQL Loader is:
-- SQLLDR control=<filename> Be sure to substitute your
-- version of SQL LOADER and the filename for this file.
LOAD DATA
INFILE *
BADFILE './tresult.BAD'
DISCARDFILE './tresult.DSC'
APPEND INTO TABLE TOTE.TRESULT
Fields terminated by ";" Optionally enclosed by '"'
(
  USERNAME,
  POINTS NULLIF (POINTS="NULL"),
  PLACE1 NULLIF (PLACE1="NULL"),
  POINTS2 NULLIF (POINTS2="NULL"),
  PLACE2 NULLIF (PLACE2="NULL"),
  POINTS3 NULLIF (POINTS3="NULL"),
  PLACE3 NULLIF (PLACE3="NULL"),
  POINTS4 NULLIF (POINTS4="NULL"),
  PLACE4 NULLIF (PLACE4="NULL"),
  POINTS5 NULLIF (POINTS5="NULL"),
  PLACE5 NULLIF (PLACE5="NULL"),
  POINTS6 NULLIF (POINTS6="NULL"),
  PLACE6 NULLIF (PLACE6="NULL"),
  POINTS7 NULLIF (POINTS7="NULL"),
  PLACE7 NULLIF (PLACE7="NULL"),
  POINTS8 NULLIF (POINTS8="NULL"),
  PLACE8 NULLIF (PLACE8="NULL"),
  POINTS9 NULLIF (POINTS9="NULL"),
  PLACE9 NULLIF (PLACE9="NULL"),
  POINTS10 NULLIF (POINTS10="NULL"),
  PLACE10 NULLIF (PLACE10="NULL"),
  STATUS_ NULLIF (STATUS_="NULL"),
  UPDTIME DATE "MM/DD/YYYY HH24:MI:SS" NULLIF (UPDTIME="NULL"),
  UPDUSER
)
BEGINDATA
"Paul";NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;NULL;210;"06/02/2010 15:23:38";"TOTE"
